select * from Common_Star_Employee	
where EmployeeNumberID = 10343100001
  go
  
select * from Common_Star_Employee	
where employeeNumber=102646
where EmployeeNumberID = 10264600001
go	

select * from Payroll_Star_Employee	
where EmployeeID = 10264600001
go

select EmployeeNumberID from Common_Star_Employee	
where EmployeeNumberID not in ( select EmployeeID from Payroll_Star_Employee	)


select C11.EmployeeNumberID, P11.EmployeeID from Common_Star_Employee C11, Payroll_Star_Employee P11
where P11.addressNumber=C11.EmployeeNumber
and C11.EmployeeNumberID<>P11.EmployeeID

update Common_Star_Employee set EmployeeNumberID=10264600001 where  employeeNumber=102646


where EmployeeNumberID not in ( select EmployeeID from Payroll_Star_Employee	)


select  * From RD_DWCR.dbo.JDEABAddressBookMaster
where 
SearchTypeCode in ( 'E ', 'X ') and 
 AddressNumber not in (select EmployeeNumber from RD_common.dbo.Star_Employee)	


select  Category21 From RD_DWCR.dbo.JDEABAddressBookMaster
where AddressNumber=102646

select  * From RD_DWCR.dbo.JDEABAddressBookMaster
where AddressNumber=102646



select * FROM RD_Common.dbo.star_employee C11
where C11.EmployeeNumber not in (Select E11.AddressNumber from RD_DWCR.dbo.JDEPYEmployeeMasterInfo E11)
and c11.EmployeeSearchTypeCode <> 'X  '
go

select * FROM RD_DWCR.dbo.JDEPYEmployeeMasterInfo E11 
where E11.AddressNumber not in (select C11.EmployeeNumber FROM RD_Common.dbo.star_employee C11 where EmployeeSearchTypeCode <> 'X  ')
go
